vaccinator
Table Name: vaccinator
The vaccinator table stores information about vaccinators, including their personal details, work-related details, and tracking preferences. This table has relationships with other tables, such as user, organization, idmapper, and vaccinationcenter.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| mappedId | int(11) | Primary Key, Foreign Key | Unique identifier for the vaccinator, linked to the idmapper table. |
| birthdate | datetime | The vaccinator's date of birth. | |
| createdDate | datetime | The date when the vaccinator's record was created. | |
| dateRegistered | datetime | The date when the vaccinator was registered. | |
| description | varchar(255) | Additional description or notes about the vaccinator. | |
| designation | varchar(50) | The vaccinator's designation or role. | |
| domicile | varchar(30) | The domicile or residential region of the vaccinator. | |
| estimatedBirthdate | tinyint(1) | Indicates whether the birthdate is estimated (1 for true, 0 for false). | |
| firstName | varchar(30) | The vaccinator's first name. | |
| gender | varchar(15) | The gender of the vaccinator. | |
| lastEditedDate | datetime | The date when the record was last edited. | |
| lastName | varchar(30) | The vaccinator's last name. | |
| middleName | varchar(30) | The vaccinator's middle name. | |
| nic | varchar(20) | National Identity Card number of the vaccinator. | |
| nicOwnerFirstName | varchar(30) | First name of the NIC owner (if different from the vaccinator). | |
| nicOwnerLastName | varchar(30) | Last name of the NIC owner. | |
| nicOwnerRelation | smallint(6) | Relationship of the NIC owner to the vaccinator. | |
| qualification | varchar(50) | The vaccinator's qualifications. | |
| vaccinationCenterId | int(11) | Foreign Key | ID of the vaccination center the vaccinator is associated with. |
| createdByUserId | int(11) | Foreign Key | ID of the user who created the vaccinator's record. |
| lastEditedByUserId | int(11) | Foreign Key | ID of the user who last edited the vaccinator's record. |
| epAccountNumber | varchar(30) | EP account number of the vaccinator. | |
| workgrouptypeId | varchar(45) | Identifier for the workgroup type the vaccinator belongs to. | |
| voided | tinyint(1) | Default 0 | Indicates if the record is voided (1 for true, 0 for false). |
| voidedReason | varchar(50) | Reason for voiding the record. | |
| organizationId | int(11) | Foreign Key | ID of the organization the vaccinator is associated with. |
| voidedDate | datetime | Date when the record was voided. | |
| IMEINumber | varchar(30) | IMEI number of the vaccinator's device. | |
| isGSMTrackingEnabled | tinyint(1) | Indicates if GSM tracking is enabled for the vaccinator. | |
| latitudeTower | varchar(45) | Latitude of the vaccinator's tower location. | |
| longitudeTower | varchar(45) | Longitude of the vaccinator's tower location. | |
| isManualTrackingEnabled | tinyint(1) | Default 0 | Indicates if manual tracking is enabled for the vaccinator. |
Indexes
- Primary Key:
- mappedId: Ensures each vaccinator has a unique identifier.
- Foreign Keys:
- FK224E4406C79271AF: Links mappedId to the idmapper table.
- vaccinator_vaccinationCenterId_vaccinationcenter_mappedId_FK: Links vaccinationCenterId to the vaccinationcenter table.
- vaccinator_createdByUserId_user_mappedId_FK: Links createdByUserId to the user table.
- vaccinator_lastEditedByUserId_user_mappedId_FK: Links lastEditedByUserId to the user table.
- organization_vaccinator: Links organizationId to the organization table.
Foreign Key Relations
- FK224E4406C79271AF:
- Referenced Table: idmapper
- Referenced Column: mappedId
- Description: Ensures the mappedId exists in the idmapper table.
- vaccinator_vaccinationCenterId_vaccinationcenter_mappedId_FK:
- Referenced Table: vaccinationcenter
- Referenced Column: mappedId
- Description: Links the vaccinator to a specific vaccination center.
- vaccinator_createdByUserId_user_mappedId_FK:
- Referenced Table: user
- Referenced Column: mappedId
- Description: Links the vaccinator's creation to a specific user.
- vaccinator_lastEditedByUserId_user_mappedId_FK:
- Referenced Table: user
- Referenced Column: mappedId
- Description: Links the last edit of the vaccinator's record to a specific user.
- organization_vaccinator:
- Referenced Table: organization
- Referenced Column: organizationId
- Description: Links the vaccinator to a specific organization.
Usage Notes
- Purpose:
- This table is crucial for tracking vaccinators' information, their association with vaccination centers, and their organizational details.
- Tracking:
- Includes features for GSM and manual tracking to monitor vaccinator activities.